import xlwings as xw
app = xw.App(visible=False, add_book=False)
workbook = app.books.open('F:\\python\\第4章\\统计表.xlsx')
worksheet = workbook.sheets[0]
area = worksheet.range('D2:D8')
area.number_format = '¥#,##0.00;¥-#,##0.00'
workbook.save('F:\\python\\第4章\\统计表1.xlsx')
workbook.close()
app.quit()
